



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
CGS1060 Final IRSC Questions with Answers Correct
Typology: Exams
1 / 7
This page cannot be seen from the preview
Don't miss anything!
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.
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.
(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.