ms office MS OFFICE QUIZ GallerySeptember 26, 2021September 26, 2021 Tally Prime 0% 0 votes, 0 avg 26 Total 15 minutes only for all 21 Questions Time up! Created on September 26, 2021 By Tally Prime MS OFFICE QUIZ This quiz has contained 21 questions on MS Office (MS Word, MS Excel, MS powerpoint). Test your knowledge on MS Office by attempting these questions.All the best ! NamePhone Number 1 / 21 What is the shortcut to underline words without space? ALT = CTRL + SHIFT + D CTRL + SHIFT + W 2 / 21 How to extract its day from a given date ? =TEXT(DATE,"DDDD") =DATE(date) =DAY(DATE) 3 / 21 Mr. Tarak need , howmany Tuesdays from the date 01-08-2021 to 01-10-2021. Then, which of these formulas helps him. =Networkdays(from date,to date,"1111101") =Networkdays(from date,to date,"1011111") =Networkdays(from date,to date,"1110111") 4 / 21 =Datedif(date,today(),”d”) Calculates the total days only with fraction Calculates the total days only without fraction Calculate the total months 5 / 21 Suppose, you need average of >1000 in a given data. Then Which of these formulas gives you output? AVERAGE AVERAGEIF AVG 6 / 21 What is the shortcut key to justify the text in ms word ? CTRL + G CRL + J CTRL + N 7 / 21 The last Cell in MS Excel is ? XFD 1048776 XFD 1048676 XFD 1048576 8 / 21 Goal seek feature available in ? MS Excel_ Data Tab MS Powerpoint_Animations Tab MS Word_Home tab 9 / 21 What is the key to update the formula results in table feature in ms word ? F7 F8 F9 10 / 21 What is the formula to repeat a character in a cell in MS Excel? =REPT(TEXT) =REPEAT(TEXT) =REP(TEXT) 11 / 21 SHIFT + F3 is the shortcut key in msword for … ? Change Case Clear formatting Paste formatting 12 / 21 How to convert horizontal data into vertical or vice versa in msexcel? With Transpose formula With Transpose feature in paste special Both 13 / 21 What is the formula to count the only numbers in a given data ? =COUNT(CELL RANGE) =COUNTA(CELL RANGE) =COUNTIF(CELL RANGE) 14 / 21 On which tab Slide layout option available in MS POWERPOINT? Insert Tab Home Tab Animations Tab 15 / 21 What is the shortcut for SUPER SCRIPT in MS Word ? CTRL + SHIFT + CTRL = ALT = 16 / 21 Len is the formula to count the _____ in a cell? Numbers only Text only Any character 17 / 21 We can Add animations or effects for selected text in …? MS Word MS Powerpoint MS Excel 18 / 21 CTRL + ALT + V is the shortcut key for ? Paste Paste Image Paste Values 19 / 21 How can you add bullets for selected text in MS Word ? Go to home tab , then paragraph group, then Click on bullets Go to insert tab , illustrations, click on bullets Go to review tab , track changes, click on bullets 20 / 21 What is the formula to change the text in Capitals letters in MS EXCEL ? =UPPER(TEXT) =LOWER(TEXT) =PROPER(TEXT) 21 / 21 What is the shortcut key to duplicate a shape in MS Word ? CTRL + C CTRL + D CTRL + K Your score is The average score is 62% LinkedIn Facebook Twitter VKontakte 0% Restart quiz Share this:Click to share on Facebook (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)MoreClick to share on Reddit (Opens in new window)Click to share on Telegram (Opens in new window) Related