Chapter test: MS Word and MS Excel

15 questions

1The Mail Merge feature in MS Word is available under which tab? AInsert BReferences CReview DMailings

2In VLOOKUP, which value must be given as the fourth argument to obtain an exact match? ATRUE BFALSE C1 DLeave it blank

3What is the file extension of an Excel Macro-Enabled Workbook? A.xlsm B.xlsx C.xltx D.csv

4When a field containing only numbers is added to the Values area of a Pivot Table, the default summary function is: ACount BAverage CSum DMax

5In MS Word, the F7 key opens: AThesaurus BSpelling and grammar check CSave As dialog DHelp

6Which keyboard shortcut turns Track Changes on or off in MS Word? ACtrl+Shift+E BCtrl+Alt+M CCtrl+Shift+T DShift+F7

7Pressing Ctrl+Enter in MS Word inserts a: ALine break BSection break CColumn break DPage break

8An office must send individual call letters to 150 candidates whose details are in an Excel sheet. Consider: 1. The main document holds the text common to all letters. 2. The Excel sheet can be the data source. 3. Merge fields can be created by typing the chevron characters from the keyboard. Which are correct? A1 and 2 only B1 only C2 and 3 only D1, 2 and 3

9Cells A2:A7 contain Approved, Pending, Approved, Rejected, approved, Approved. What is the result of =COUNTIF(A2:A7, "Approved")? A3 B5 C2 D4

10B2 holds 55 for attendance percentage and C2 holds 72 for marks. What does =IF(AND(B2>=50, C2>=75), "Eligible", "Not Eligible") return? AEligible BTRUE CNot Eligible D#VALUE!

11Which shortcut inserts the current date into an Excel cell? ACtrl+Shift+; BAlt+= CCtrl+; DCtrl+D

12Which error value does Excel display when a formula divides a number by an empty cell? A#VALUE! B#DIV/0! C#N/A D#REF!

13Cell C1 contains the formula =A1*$B$1. If it is copied to cell C3, what will C3 contain? A=A1*$B$1 B=A3*$B$1 C=A3*$B$3 D=C3*$B$1

14How many columns does a worksheet contain in Excel 2007 and later? A256 B65,536 C16,384 D1,048,576

15Departments are in A2:A6 as Civil, Mech, Civil, CSE, Civil and amounts in B2:B6 as 5000, 3000, 7000, 4000, 2000. What is the result of =SUMIF(A2:A6, "Civil", B2:B6)? A21000 B12000 C7000 D14000

Back to MS Word and MS Excel