Microsoft Excel Spreadsheet Software Programs Quiz

5 Questions | By AdrielEphraim | Last updated: Mar 20, 2022 | Total Attempts: 150

The purpose of this assessment is to help us determine proficiency levels in our company, and where to focus our efforts in upcoming training classes. Your individual results will be scored and used as a basis for your training needs.

Questions and Answers

1.

The DEFAULT number of worksheets in an Excel Workbooks is ___?
- A.
  
  There is no default. It has to be set each time Excel is opened.
- B.
  
  3
- C.
  
  255
- D.
  
  1
- E.
  
  Not Sure
2.

One way to enter data into a cell is by typing into the formula bar and clicking on the check mark button.
- A.
  
  True
- B.
  
  False
- C.
  
  Not Sure
3.

If a cell has the contents, 25048.50 and has been formatted to acurrency format with no decimals places, which of the following willappear in the cell?
- A.
  
  25,048
- B.
  
  25,049.00
- C.
  
  $25,048.50
- D.
  
  $25,049
- E.
  
  Not Sure
4.

You can rename worksheets by either double clicking or right clickingon the tab. When the tab is highlighted, you can retype the new name.
- A.
  
  True
- B.
  
  False
- C.
  
  Not Sure
5.

The only formats you can choose for numbers in a chart are currency,fractions, or percentages.
- A.
  
  True
- B.
  
  False
- C.
  
  Not Sure