Spreadsheet Modeling Exam Questions and Answers 100% Pass

Spreadsheet Modeling Exam Questions and Answers 100% Pass Excel is an electronic version of a(n) ____. -Answer-Spreadsheet Excel stores its documents as files called ____. -Answer-Workbooks The contents of an active cell are displayed in the ____. -Answer-Formula bar The name given to an Excel workbook before you rename it is ____. -Answer-Book1 By default, an Excel workbook is made up of ____ worksheets. -Answer-Three Row headings identify each row using a different ____. -Answer-Number The intersection of a row and column is known as a ____. -Answer-Cell To go to column A of the current row, click ____. -Answer-Home To make A1 the active cell, you should press which of the following keys? -Answer-Ctrl +Home To complete a cell entry, press the ____ key. -Answer-Enter The characters +, -, *, and / are examples of ____. -Answer-Arithmetic Operators An Excel formula always begins with a(n) ____. -Answer-Equals Sign The formula used to multiply cell A1 by cell C1 is ____. -Answer-A1*C1 To divide the value of a cell by some number, use the ____ operator. -Answer-/ A(n) ____ is a group of cells. -Answer-Range To view formulas, rather than the resulting values in a worksheet, switch to ____. - Answer-Formula View To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other adjacent ranges. -Answer-Ctrl To select a large range of cells, click the first cell in the range, press and hold ____, and then click the last cell in the range. -Answer-Shift What is the result of the expression =50/(10*5)? -Answer-1 Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet. -Answer-color coding To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column. -Answer-AutoFit Which of the following takes precedence over multiplication? -Answer-Exponentiation In ____ orientation, a page is taller than it is wide. -Answer-portrait According to the order of precedence in Excel: -Answer-Excel performs exponentiation, then multiplication and division, then addition and subtraction. What type of operation does the formula "C9/B10" use? -Answer-Division To change the font size one point at a time, in the Font group on the Home tab, click the ____ button. -Answer-Increase/Decrease Font size By default, numbers appear in the ____ and generally display values exactly as you type them. -Answer-general number format Which of the following can you format using the Number group in Excel's home tab? - Answer-currency formats numbers to percentages commas as a thousands separator Because Excel stores dates and times as ____, you can apply different formats without affecting the date and time value. -Answer-Numbers