Advanced Business SIMNET Quiz
Questions and Answers
Which of the following shortcuts opens a new blank - Answer-Ctrl+N
Which of the following keyboard shortcuts opens the Format cells dialog box? - Answer-Ctrl+1
Which of the following displays the result of a formula? - Answer-cell
Which of the following statements is true? - Answer-The number of sheets you can insert in a workbook
is limited only by the amount of memory available on your computer
Which of the following commands should you use to prevent column and row headings from scrolling
off the screen? - Answer-Freeze Panes command
Which of the following commands lets you display a label on multiple lines within a cell? - Answer-Wrap
Text
Which of the following can't be added to the info pane in the Backstage view of a Microsoft Excel file? -
Answer-timing
, Which of the following Page Setup options lets you set the Print area by selecting a specified range of
cells? - Answer-Sheet
Which of the following best describes the size of an Excel 2016 worksheet? - Answer-over 16,000
columns and 1 million rows
Which of the following statements is not true? - Answer-You can hide a worksheet even if there is only
one sheet in the workbook
Which of the following simplifies the process of entering the months of the year in a worksheet? -
Answer-Fill Handle tool
Which of the following displays when you place your pointer on the border of an active cell or cells? -
Answer-Move pointer
Which of the following must you press to enter a manual line break in a cell? - Answer-Alt+Enter
Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you
use to save it again? - Answer-Ctrl+S
Which of the following views lets you apply headers and footers and view the layout of the spreadsheet
prior to distribution? - Answer-Page Layout view
Which of the following is helpful for inserting formulas and editing data? - Answer-Formula bar
Before using the Merge & Center command, what cell should contain the data? - Answer-upper left cell
Questions and Answers
Which of the following shortcuts opens a new blank - Answer-Ctrl+N
Which of the following keyboard shortcuts opens the Format cells dialog box? - Answer-Ctrl+1
Which of the following displays the result of a formula? - Answer-cell
Which of the following statements is true? - Answer-The number of sheets you can insert in a workbook
is limited only by the amount of memory available on your computer
Which of the following commands should you use to prevent column and row headings from scrolling
off the screen? - Answer-Freeze Panes command
Which of the following commands lets you display a label on multiple lines within a cell? - Answer-Wrap
Text
Which of the following can't be added to the info pane in the Backstage view of a Microsoft Excel file? -
Answer-timing
, Which of the following Page Setup options lets you set the Print area by selecting a specified range of
cells? - Answer-Sheet
Which of the following best describes the size of an Excel 2016 worksheet? - Answer-over 16,000
columns and 1 million rows
Which of the following statements is not true? - Answer-You can hide a worksheet even if there is only
one sheet in the workbook
Which of the following simplifies the process of entering the months of the year in a worksheet? -
Answer-Fill Handle tool
Which of the following displays when you place your pointer on the border of an active cell or cells? -
Answer-Move pointer
Which of the following must you press to enter a manual line break in a cell? - Answer-Alt+Enter
Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you
use to save it again? - Answer-Ctrl+S
Which of the following views lets you apply headers and footers and view the layout of the spreadsheet
prior to distribution? - Answer-Page Layout view
Which of the following is helpful for inserting formulas and editing data? - Answer-Formula bar
Before using the Merge & Center command, what cell should contain the data? - Answer-upper left cell
