Xcel exam review - Study guides, Class notes & Summaries

Excel Final Exam Review 2023/2024 ( graded A+ 100% verified)

Excel Final Exam Review 211 Questions with Verified Answers Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? - CORRECT ANSWER B. Show Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT ANSWER A. Workbook Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? - CORRECT ANSWER A. Page Layout Which of the following would you use to...

Which of these methods can you use to enter a formula using the average function? a. Formula Auto Complete b. AutoSum c. Function Arguments dialog d. All of the above - D. all of the above To count the number of cells that contain text or numerical values, but not blanks, use which function? a. COUNT b. COUNTALL c. COUNTA d. COUNTBLANK - c. COUNTA Which of these functions returns the current date and time? a. Time b. Date c. Now d. Today - c. Now What is the definition of concaten...

XCEL Chapter 4 Exam Review (1) UPDATED Exam Questions and CORRECT Answers Decreasing term policies - CORRECT ANSWER - EX. mortgages. Policy amount decreases as the outstanding mortgage balance decreases each year Term policies - CORRECT ANSWER - Renewable, convertible, or renewable AND convertible

XCEL Chapter 4 Exam Review (1) Questions and Answers

electronic spreadsheet - Answer-an application you use to perform numeric calculations and to analyze and present numeric data worksheet/workbook - Answer-the electronic spreadsheet you work in is a worksheet, it is contained in a file called a workbook name box - Answer-displays the active cell address formula bar - Answer-allows you to enter or edit data in the worksheet cell - Answer-the intersection of a column and a row sheet tabs - Answer-let you switch from sheet to sheet i...

XCEL Chapter 1 Exam Review Questions and Answers

XCEL Chapter 4 Exam Review (2) Questions and Answers

XCEL Chapter 4 Exam Review (1) Questions and Answers 100% Pass Decreasing term policies - EX. mortgages. Policy amount decreases as the outstanding mortgage balance decreases each year Term policies - Renewable, convertible, or renewable AND convertible Nonforfeiture values - Cash value The MEC tends to be an investment vehicle - Pre-death distributions from a modified endowment contract (MEC) receive different tax treatment than other life insurance policies because Pre-death distribut...

Microsoft Excel Exam Review Ch. 1-7 Questions And Correct Answers |Verified