Excel Multiple choice exam | with actual questions and answers 2023/24

Excel Multiple choice exam | with actual questions and answers 2023/24 In general, use no more than ___ font types in a worksheet - two clicking the ____box completes an entry - enter to enter a number as text, precede it with a(n)____ - apostrophe ' The ___button is located on the Quick Access Toolbar - undo to cancel an entire entry before entering it into the cell, press the ___ key - ESC which of the following keys toggles between insert mode and overtype mode? - INSERT you can enter the correct range in a function by typing the beginning and ending cell references separated by a ____ - colon : Pressing the ___ key to complete an entry activates the adjacent cell to the right - Right Arrow What effect does the comma style format have on selected cells? - Displays cell contents with two decimal places and commas as thousands seperators The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting - Auto Fill options What effect does the Accounting Number Format have on selected cells? - Displays cell contents with two decimal places that align vertically The person or persons requesting the worksheet should supply their requirements in a ___ document - requirements how many chart types does excel offer? - 11 In Excel, a number can contain the characters___- - 0-9