1. Which function in Excel is used to add a range of numbers?, COUNT, SUM, MAX, MIN, What is the shortcut button on the toolbar that quickly adds a column or row of numbers?, AutoFormat, AutoSum, AutoFill, AutoCorrect, What will the formula =SUM(10,20,30) return?, 30, 50, 60, 100, Which Excel function is used to count the number of numeric entries in a range?, SUM, COUNT, AVERAGE, MAX, If cells A1 to A5 contain 5, 7, 9, 2, 4, what is the result of =AVERAGE(A1:A5)?, 5.4, 7, 27, 4, Which function will find the largest value in a set of numbers?, MIN, MAX, AVERAGE, COUNT, Which function will return the smallest value in a range?, MAX, SUM, MIN, COUNT, What does the function =TODAY() display in an Excel cell?, The word “TODAY”, The system time, The current date, The month name, Which of these formulas will add the values in cells B1 to B10?, =ADD(B1:B10), =COUNT(B1:B10), =SUM(B1:B10), =TOTAL(B1:B10), What is the difference between SUM and AutoSum?, AutoSum guesses the range automatically, SUM requires you to type it, They are completely different, AutoSum finds maximum values, SUM only works for text values, If cells contain 3, 5, and 7, what will =COUNT(A1:A3) return?, 15, 3, 5, 7, The AutoSum button on the Home tab is used to, Automatically correct spelling, Quickly add a column or row of numbers, Format cells with colors, Draw shapes, If A1=5, A2=15, A3=10, then =MAX(A1:A3)-MIN(A1:A3) equals:, 10, 20, 15, 5.

ICT

بواسطة
طباعة
تضمين

لوحة المتصدرين

شاهد أفضل اللاعبين

لوحة الصدارة

النمط البصري

الخيارات

تبديل القالب

لوحة المتصدرين

شاهد أفضل اللاعبين
)
استعادة الحفظ التلقائي: ؟