9 out of 10 based on 616 ratings. 1,040 user reviews.

# EXCEL FORMULAS KNOWLEDGE TEST QUESTIONS

Excel Test - 20 Questions to Test Your Excel Knowledge!
What is the keyboard shortcut key to lock cell references in a formula?* CTRL. ALT. F2. F4.What are the shortcut keys for AutoSum?* ALT and S. CTRL and S. ALT and = CTRL and =Which of the following is the correct formula to calculate the weighted average score in cell C8 as Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as See all full list on corporatefinanceinstitute
Free Excel Test Sample Questions - JobTestPrep
Excel Sample Questions. To answer the sample questions, copy the following table to a new Excel spreadsheet. The cell marked with (A1) must be pasted in cell A1 on the spreadsheet. Once the table has been copied, continue to the following question.
Excel Formulas And Functions! Trivia Quiz - ProProfs Quiz
Jun 07, 2019Do you know all the functions and formulas? If yes, then take this quiz to test where do you stand and learn new formulas and functions used in excel. Microsoft Excel is a spreadsheet software which is used for data processing and financial presentation. To become an expert one needs to learn the formulas and functions. So, let's try out the quiz.
Excel Formulas & Functions - Practice Test Questions
Excel Formulas & Functions Chapter Exam. Exam Instructions: Choose your answers to the questions and click 'Next' to see the next set of questions. You can skip questions if you would like and come back to them later with the yellow "Go To First Skipped Question" button. When you have completed the practice exam
Test Your Excel Basic Knowledge - ProProfs Quiz
Jan 11, 2019Test Your Excel Basic Knowledge. The default font keyed in a new work book is. If you choose a larger font size, the height of the row is automatically made taller. Which button allows you to copy cell formats from one cell to another? A_______ is a
MS Excel Questions & Answers | Basic Computer Knowledge
MS Excel Questions & Answers. Ctrl + Tab Move between two or more open Excel files. Alt + = Create a formula to sum all of the above cells. Ctrl + ' Insert the value of the above cell into cell currently selected. Ctrl + Shift + ! Format number in comma format. Ctrl + Shift + \$ Format number in currency format.