Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

CGS1060 Final IRSC Questions with Answers Correct, Exams of Nursing

CGS1060 Final IRSC Questions with Answers Correct

Typology: Exams

2024/2025

Available from 07/07/2025

lisa-writer
lisa-writer 🇺🇸

815 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CGS1060 Final | IRSC Questions with
Answers Correct
A new Blank Workbook in Excel 2013 contains one worksheet named: -
ANSWERSSheet1
Press the ______ key to move the active cell one position to the right on the worksheet.
- ANSWERSTab
The default name for an Excel file is _______. - ANSWERSBook1
A ____ is referenced by a column letter and row number such as C5. - ANSWERSCell
An Excel file is referred to as a: - ANSWERSWorkbook
This bar displays entries as they are made and edited in the Excel workbook window
and also shows the actual formula used to calculate the value shown in the worksheet
cell. - ANSWERSFormula
By clicking the File tab from the Excel ribbon, you have entered the _________ view. -
ANSWERSBackstage
To save a workbook in a format compatible with earlier Excel versions, the file extension
should be: - ANSWERS.xls
If you're sharing your data with someone who does not have Excel or any sort of
spreadsheet software on their computer, you may want to save your workbook in this
format: - ANSWERS.pdf
In Excel, the program name and name of the open file are displayed in the: -
ANSWERSTitle bar
Excel 2013 files have names that end with a default file extension of ____ . -
ANSWERS.xlsx
____________ is the process of changing the appearance of cells and the overall layout
of the worksheet. - ANSWERSFormatting
pf3
pf4
pf5

Partial preview of the text

Download CGS1060 Final IRSC Questions with Answers Correct and more Exams Nursing in PDF only on Docsity!

CGS1060 Final | IRSC Questions with

Answers Correct

A new Blank Workbook in Excel 2013 contains one worksheet named: - ANSWERSSheet Press the ______ key to move the active cell one position to the right on the worksheet.

  • ANSWERSTab The default name for an Excel file is _______. - ANSWERSBook A ____ is referenced by a column letter and row number such as C5. - ANSWERSCell An Excel file is referred to as a: - ANSWERSWorkbook This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell. - ANSWERSFormula By clicking the File tab from the Excel ribbon, you have entered the _________ view. - ANSWERSBackstage To save a workbook in a format compatible with earlier Excel versions, the file extension should be: - ANSWERS.xls If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format: - ANSWERS.pdf In Excel, the program name and name of the open file are displayed in the: - ANSWERSTitle bar Excel 2013 files have names that end with a default file extension of ____. - ANSWERS.xlsx ____________ is the process of changing the appearance of cells and the overall layout of the worksheet. - ANSWERSFormatting

Use the ____________ command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it. - ANSWERSWrap Text ___________ is used to copy the formatting of one cell to other cells. - ANSWERSFormat Painter The background of a cell is called the: - ANSWERSFill color By default, textual data is ____ aligned within Excel cells - ANSWERSLeft Combining two or more cells into a single cell creates a: - ANSWERSMerged cell Cell ________ such as Heading and Title allow you to apply multiple formats to a cell at once. - ANSWERSStyles The edges or lines around a cell are referred to as the cell's: - ANSWERSBorder If you have a column of data that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format. - ANSWERSCurrency Flash Fill is: - ANSWERSAn Excel method that lets you gather data from multiple worksheets or workbooks into a master worksheet that acts as a summary. Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1? - ANSWERSSaturday, April 12, 2014 Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell? - ANSWERS0.0017% The ____________ feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting. - ANSWERSAuto Fill In Excel, a black symbol in the lower right-hand corner of the active cell. Users can click and drag the fill handle to copy cell contents or create a series. - ANSWERSFill Handle (PowerPoint) PowerPoint allows you to insert tables into your slides. Tables are organized by columns and rows, the intersection of which is called a: - ANSWERSBorder (Excel) To automatically add row and column headers and analyze a group of related data independenly from other cells in the worksheet, you can convert a range of cells to a(n): - ANSWERSExcel table

(PowerPoint) PowerPoint allows you to insert tables into your slides. Tables are organized by columns and rows, the intersection of which is called a: - ANSWERSCell (PowerPoint) When an Excel spreadsheet has been inserted into a slide from within PowerPoint, you will have access to some of the Excel functions. True or False? - ANSWERSTrue (PowerPoint) Suppose that you would like to include data in your presentation that comes from an existing Excel spreadsheet. You also want the ability to change data in the PowerPoint presentation table and have it also make the corresponding change in the Excel spreadsheet file. How can you do this? - ANSWERSChoose "Insert Object" in PowerPoint and "Link" the spreadsheet to the slide. (PowerPoint) When you click on an object on your slide such as a table or picture, you will be presented with one or more new tabs on the PowerPoint ribbon. These tabs are called _____ because they are specific to the type of item or object you have selected on the slide. - ANSWERSContextual (PowerPoint) The outer edge or line around a table is referred to as its: - ANSWERSBorder (PowerPoint) Which PowerPoint tool could be used to quickly and easily depict a series of steps or levels using a pyramid shape with the ability to add your own text to the diagram? - ANSWERSSmartArt (PowerPoint) A PowerPoint compilation, editing, and organizing feature that allows the user to compile groups of pictures for use in presentations or on the Web. - ANSWERSPhoto Album (PowerPoint) A feature that allows the duplication of animation effects between objects.

  • ANSWERSAnimation Painter (PowerPoint) Because of possible copyright infringements, PowerPoint does not allow song clips or music to be added to presentations. True or False? - ANSWERSFalse (PowerPoint) To reduce the size of your PowerPoint presentation, you should _____ video clips. - ANSWERSLink to (PowerPoint) A simulation of movement added to graphics or text on a slide is called: - ANSWERSAnimation (PowerPoint) Animations are always applied to objects; they are not applied to the slide itself. True or False? - ANSWERSTrue (PowerPoint) A special effect that marks how one slide moves off and the next slide moves onto the screen is called a(n): - ANSWERSTransition

(PowerPoint) Which PowerPoint ribbon tab gives you access to the Comments and Compare command groups which are helpful when collaborating with a group on a presentation? - ANSWERSReview (PowerPoint) Which command group from the Review tab allows us to merge two copies of a presentation so that we may either accept or reject changes that have been made to it by another person? - ANSWERSCompare (PowerPoint) The ability to translate your presentation into several different languages is built right into the PowerPoint program. You do not have to download any Add-ons to the program to enable this feature. True or False? - ANSWERSTrue (Access) Information in a database is typically stored in this, which consists of vertical columns and horizontal rows. - ANSWERSTable (Access) RDBMS is an acronym for: - ANSWERSRelational Database Management System (Access) The field that uniquely identifies each record in a table is called a: - ANSWERSPrimary Key (Access) The main purpose of a form is to: - ANSWERSView and enter data into tables. (Access) The purpose of a query is to: - ANSWERSAsk questions and display specific data from a table. (Access) A database object that summarizes the fields and records from a table in an attractive, easy-to-read format is a: - ANSWERSReport (Access) Each row in an Access table contains a(n) _____ which consists of multiple fields of information. - ANSWERSRecord (Access) Each individual chunk of data that collectively make up a record in a database is called a: - ANSWERSField (Access) Which of the following views in Microsoft Access is used for entering actual data into records? - ANSWERSDatasheet view (Access) Which of the following views in Microsoft Access is used for changing the design and structure of tables? - ANSWERSDesign view (Access) If a relationship is established between two tables they will share a common: - ANSWERSField

(Access) Each row in a table contains a(n): - ANSWERSRecord (Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the: - ANSWERSPrice field in descending ordrer (Access) Formatting the appearance of the table will not change the data, just the way you're looking at it. True or False? - ANSWERSTrue If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use: Copy or Cut? - ANSWERSCopy!!! When you start the Excel program, you can choose to start with a new blank workbook or one of many pre-formatted workbooks called _______. - ANSWERSTemplates An Excel workbook can consist of multiple _______ or "pages" each referenced by a tab at the bottom of the Excel program window. - ANSWERSWorksheets An Excel file is referred to as a: - ANSWERSWorkbook If you begin typing, the characters will appear in the cell of the worksheet known as the ______ cell that has its border bolded with a green color. - ANSWERSActive Cell Press the ______ key to move the active cell one position to the right on the worksheet.

  • ANSWERSTab A new Blank Workbook in Excel 2013 contains one worksheet named: - ANSWERSSheet 1 This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell. - ANSWERSFormula The default name for an Excel file is _______. - ANSWERSBook