Excel Core

Your created a invoice spreadsheet with some macros. This spreadsheet is to be used by everyone in the office as a template. Which file format should you stored this workbook?

• Excel Workbook

• Excel Macro-enabled Workbook

• Web Page

• Excel Macro-Enabled Template

What is the purpose of the icon highlighted in red circle?

• I click here to autohide or show tabs or show tabs and commands

• I click here to close my Excel spreadsheet program

• I click here to show my slicers

• I click here to do my Autosum

This section of Excel allows me to do which commands? (More than 1 answer)

• Create a new function

• Open an existing file

• View my Excel setup

• Create a blank spreadsheet

I can click there to go to a specific cell within the worksheet

• True

• False

Which statement is true?

• Use Row Height to the width of the column

• Use Clear Contents

• Use Row Height to increase the height of the row

• Use Row Height to increase the size of the words

which is the correct function?

• =IF(Income > $80,000, 12%, 8%)

• =IF(Income <= $80,000, 12%, 8%)

• =IF(Income >= $80,000, 12%, 8%)

• =if(Income < $80,000, 12%, 8%)

• Click here to insert new worksheet

• Click to show tabs and commands or to autohide

• Click here to start Excel

• Click to minimise or restore spreadsheet window

You are intending to work from home but your home computer is using Excel 2000 while in the office, the Excel version is 2016.

• You need to upgrade your Excel version at home before you can work from home

• You can save your work as Excel 97 - 2003 workbook then use it at your home computer

• You can still work from home because the Excel in your home computer will automatically recognise it is an Excel file

• You can't work from home. It is impossible because your Excel version at home is too old.

• Click here to change Zoom view to 78%

• You cannot change the Zoom view %

• You can only choose the Zoom magnification % provided

• Use the Zoom slider in the worksheet view to change Zoom size as that is the only way

Excel has a function to sum up all values of a specific column without criteria

• SUM

• SUMIF

• Add

• Total