Excel Sheet Format For Quiz Questions

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Minhpd.87
M
Minhpd.87
Community Contributor
Quizzes Created: 1 | Total Attempts: 79
| Attempts: 79
SettingsSettings
Please wait...
  • 1/75 Questions

    Trong Microsoft Excel, ham SUM dung de lam gi?

    • Tinh tong cac gia tri so trong vung duoc chon
    • Tim gia tri nho nhat trong cac gia tri duocchon
    • Tim gia tri lon nhat trong cac gia tri duoc chon
Please wait...
About This Quiz


The use of excel spreadsheets is one of the hard things to comprehend in the computer use. However, not everyone really uses excel, but it is widely used especially for official purposes. The quiz below tests this and more,

Excel Sheet Format For Quiz Questions - Quiz

Quiz Preview

  • 2. 

    Trong Microsoft Excel, phuomg an nao duoi day la dia chi hon hop?

    • A12$

    • $A12

    • $A$12

    Correct Answer
    A. $A12
    Explanation
    The correct answer is $A12. In Excel, a mixed reference is a combination of a relative reference and an absolute reference. In this case, the column reference is absolute ($A) while the row reference is relative (12). This means that when the formula is copied to other cells, the column reference will stay the same, but the row reference will change based on the relative position of the new cell.

    Rate this question:

  • 3. 

    Trong Microsoft Excel, cach nao de luu tep hien tai voi ten moi?

    • F10

    • F12

    • F11

    Correct Answer
    A. F12
    Explanation
    In Microsoft Excel, pressing the F12 key allows you to save the current file with a new name. This shortcut key opens the "Save As" dialog box, where you can specify a new name and location for the file. By using F12, you can quickly save a copy of the current file without overwriting the original version.

    Rate this question:

  • 4. 

    Trong Microsoft Excel 2003, khi ve bieu do bang cong cu Chart Wizard, the Data Range cho phep lam gi?

    • Gan nhan cho vung du* lieu

    • Thay doi vung du lieu ve bieu do

    • Xoa du lieu

    Correct Answer
    A. Thay doi vung du lieu ve bieu do
    Explanation
    The correct answer is "Thay doi vung du lieu ve bieu do" which means "Change the data range for the chart" in English. This option allows the user to modify the range of data that is used to create the chart. By selecting this option, the user can choose a different set of data to be plotted on the chart, allowing for customization and flexibility in visualizing the data.

    Rate this question:

  • 5. 

    Trong Microsoft Excel, cong thuc =MAX(30,10,65,5) nhan duoc ket qua la bao nhieu?

    • 120

    • 110

    • 65

    Correct Answer
    A. 65
    Explanation
    The correct answer is 65 because the MAX function in Microsoft Excel is used to find the highest value among a set of numbers. In this case, the set of numbers is 30, 10, 65, and 5. The MAX function will return the highest value from this set, which is 65.

    Rate this question:

  • 6. 

    Trong Microsoft Excel, cong thuc nao dung?

    • =SUM(A1:B5)

    • =SUM(A1..B5)

    • =SUM < A1:B5 >

    Correct Answer
    A. =SUM(A1:B5)
    Explanation
    The correct answer is =SUM(A1:B5). This formula is used in Microsoft Excel to calculate the sum of values in a range of cells, from cell A1 to cell B5. The SUM function adds up all the numbers in the specified range and returns the total sum.

    Rate this question:

  • 7. 

    Trong Microsoft Excel, cu phap ham nao la dung?

    • =ranks(number,ref,[order])

    • =ranke(number,ref,[order])

    • =rank(number,ref, [order])

    Correct Answer
    A. =rank(number,ref, [order])
    Explanation
    The correct answer is =rank(number,ref, [order]). This function is used in Microsoft Excel to determine the rank of a specified number in a given range. The "number" argument represents the value that you want to rank, the "ref" argument is the range of cells that contains the values, and the optional "order" argument specifies whether to rank the numbers in ascending or descending order. This function is helpful when you want to compare and analyze data based on their rankings.

    Rate this question:

  • 8. 

    Trong Microsoft Excel, cong thuc = MIN(0,2,3,4,1) cho ket qua nao?

    • 1

    • 10

    • 0

    Correct Answer
    A. 0
    Explanation
    The MIN function in Microsoft Excel is used to find the smallest value among a set of numbers. In this case, the set of numbers is 0, 2, 3, 4, and 1. The function will compare these numbers and return the smallest value, which is 0. Therefore, the correct answer is 0.

    Rate this question:

  • 9. 

    Trong Microsoft Excel, tai o A2 co du lieu "1Hanoi2”. Su dung Fill hand de dien du lieu den cac o B2，C2，D2, E2; tai o E2 nhan duoc ket qua nao?

    • 1Hanoi4

    • 1Hanoi 5

    • 1Hanoi6

    Correct Answer
    A. 1Hanoi6
    Explanation
    Using the Fill handle in Excel, the data in cell A2 ("1Hanoi2") is filled into cells B2, C2, D2, and E2. Therefore, the value in cell E2 will be "1Hanoi6".

    Rate this question:

  • 10. 

    Trong Microsoft Excel, phuong an nao duoi day la dia chi tuyet doi?

    • $A$12

    • $12$A

    • A$12$

    Correct Answer
    A. $A$12
    Explanation
    The correct answer is $A$12 because in Microsoft Excel, a cell reference with both column and row specified with dollar signs ($) is called an absolute cell reference. This means that no matter where the cell is copied or moved to, the reference will always point to the same cell. In this case, $A$12 specifies that the cell being referred to is in column A and row 12, and the dollar signs indicate that this reference is absolute.

    Rate this question:

  • 11. 

    Trong Microsoft Excel, cach nao de mo mot tep Excel da co tren may tinh?

    • Ctrl十M

    • Ctrl+N

    • Ctrl+O

    Correct Answer
    A. Ctrl+O
    Explanation
    To open an existing Excel file in Microsoft Excel, you can use the shortcut Ctrl+O. This shortcut allows you to access the Open dialog box, where you can browse and select the desired Excel file from your computer. By using this shortcut, you can quickly and efficiently open Excel files without having to navigate through the menus and options in the Excel application.

    Rate this question:

  • 12. 

    Trong Microsoft Excel, thao tac nao de doi ten bang tinh

    • Kich phai chuot tai ten bang tinh/ New/ Nhap ten mai/ Enter

    • Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter

    • Kich phai chuot tai ten bang tinh/ Newname/ Nhap ten moi/ Enter

    Correct Answer
    A. Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter
    Explanation
    To rename a worksheet in Microsoft Excel, you need to right-click on the sheet name, select "Rename," enter the new name, and press Enter.

    Rate this question:

  • 13. 

    Trong Microsoft Excel 2003，cach nao de tao duong vien cho o da chon?

    • Format/ Cells/ Colors

    • Format/ Borders/ Pattern

    • Format/ Cells/ Border

    Correct Answer
    A. Format/ Cells/ Border
    Explanation
    In Microsoft Excel 2003, to create a border for the selected cell, you need to go to the Format menu, then select Cells, and finally choose the Border option. This allows you to add borders to the selected cells in Excel 2003.

    Rate this question:

  • 14. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro sang phai cua o hien hanh?

    • Tab

    • Enter

    • Backspace

    Correct Answer
    A. Tab
    Explanation
    In Microsoft Excel, the Tab key allows you to move the cursor to the right of the current cell. This is useful when you want to quickly navigate through different cells in a row or when you want to enter data in the cell to the right of the current one.

    Rate this question:

  • 15. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro len vi tri man hinh khuat tren?

    • Page Up

    • Page Down

    • Home

    Correct Answer
    A. Page Up
    Explanation
    Page Up is the correct answer because it allows the user to move the cursor up to the previous visible screen position in Microsoft Excel. This can be useful when working with large spreadsheets that require scrolling, as it allows for quick navigation to the top of the visible area.

    Rate this question:

  • 16. 

    Trong Microsoft Excel 2003，cach nao de sao chep dir lieu trong vung da Chon?

    • Edit/ Replace

    • Edit/ Copy

    • Edit/ Cut

    Correct Answer
    A. Edit/ Copy
    Explanation
    In Microsoft Excel 2003, to copy data within a selected range, the user can use the "Edit/Copy" option. This option allows the user to duplicate the selected data and place it in another location within the spreadsheet or in a different worksheet. By selecting the desired range, clicking on "Edit" in the menu bar, and then choosing "Copy," the user can easily duplicate the data. This option is useful when the user wants to create multiple copies of the same data or when they want to move the data to a different location without deleting the original.

    Rate this question:

  • 17. 

    Trong Microsoft Excel 2003，cach nao de sap xep du lieu theo thur tu tang dan?

    • Data/ Sort by / Descending

    • Data/ Sort/ Descending

    • Data/ Sort/ Ascending

    Correct Answer
    A. Data/ Sort/ Ascending
    Explanation
    To sort data in ascending order in Microsoft Excel 2003, you need to go to the "Data" tab, then select "Sort" and finally choose "Ascending". This will arrange the data in increasing order based on the selected column.

    Rate this question:

  • 18. 

    Trong Microsoft Excel 2003, chon Data/ Filter de thuc hien cong viec gi?

    • Tong hop du"lieu

    • Trich loc du lieu

    • Sap xep du lieu

    Correct Answer
    A. Trich loc du lieu
    Explanation
    In Microsoft Excel 2003, selecting Data/Filter allows you to extract or filter specific data from a larger dataset. This feature enables you to display only the data that meets certain criteria or conditions, making it easier to analyze and work with the relevant information. By selecting this option, you can narrow down the dataset and focus on the specific data that you need for your task or analysis.

    Rate this question:

  • 19. 

    Trong Microsoft Excel, cong thu'c =SUM(19,11,MAX(1,3,5)) se cho ket qua la bao nhieu?

    • 31

    • 30

    • 35

    Correct Answer
    A. 35
    Explanation
    The correct answer is 35 because the SUM function is used to calculate the sum of the numbers given as arguments. In this case, the numbers are 19, 11, and the result of the MAX function which returns the maximum value among the numbers given as arguments (1, 3, and 5). The maximum value is 5, so the sum of 19, 11, and 5 is 35.

    Rate this question:

  • 20. 

    Trong Microsoft Excel, ham nao de tim so nho nhat trong cac gia tri duoc chon?

    • MINUM

    • MIN

    • MINUTE

    Correct Answer
    A. MIN
    Explanation
    The correct answer is MIN. In Microsoft Excel, the MIN function is used to find the smallest value in a selected range of values. It calculates and returns the minimum value from the given range.

    Rate this question:

  • 21. 

    Trong Microsoft Excel, cong thuc =M1NE(0,1,2,3) cho ket qua nao?

    • #NAME?

    • 3

    • 0

    Correct Answer
    A. #NAME?
    Explanation
    The formula =M1NE(0,1,2,3) in Microsoft Excel is not recognized as a valid function. Therefore, it returns the error message #NAME?.

    Rate this question:

  • 22. 

    Trong Microsoft Excel 2003, cach nao de loc du* lieu tu dong?

    • Data/ Filter/ Advance Fitter

    • Data/ Auto/ Filter

    • Data/ Filter/ AutoFilter

    Correct Answer
    A. Data/ Filter/ AutoFilter
    Explanation
    In Microsoft Excel 2003, to automatically filter data, you can use the option "Data/Filter/AutoFilter". This feature allows you to quickly filter data based on specific criteria, making it easier to analyze and work with large datasets.

    Rate this question:

  • 23. 

    Trong Microsoft Excel 2003, hop thoai Chart Options cho phep dua cac thong tin nao sau day cho bieu do?

    • Hien thi hay khong hien thi cac gia tri tren bieu do

    • Bao gom ca 2 phiromg an con lai

    • Tieu de cua bieu do, tieu de cac true, cac kieu dirorng ludi trong bieu do

    Correct Answer
    A. Bao gom ca 2 phiromg an con lai
    Explanation
    The Chart Options dialog box in Microsoft Excel 2003 allows you to include both the display or non-display of values on the chart and the title of the chart, as well as the titles of the axes and the type of data labels in the chart.

    Rate this question:

  • 24. 

    Trong Microsoft Excel, cach nao de tao moi mot tep?

    • Ctrl+N

    • Ctrl + M

    • Ctrl + O

    Correct Answer
    A. Ctrl+N
    Explanation
    To create a new file in Microsoft Excel, you can use the shortcut Ctrl+N. This shortcut opens a new workbook, allowing you to start working on a new spreadsheet.

    Rate this question:

  • 25. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro xuong vi tri man hinh khuat duoi?

    • Page Down

    • Home

    • Page Up

    Correct Answer
    A. Page Down
    Explanation
    Page Down là phím tắt trong Microsoft Excel cho phép di chuyển con trỏ xuống vị trí màn hình khuất dưới.

    Rate this question:

  • 26. 

    Trong Microsoft Excel 2003，cach nao cho phep tao bieu do cho vung gia tri duoc chon?

    • Insert/ Bar Chart

    • Insert/ Chart

    • Insert/ Column Chart

    Correct Answer
    A. Insert/ Chart
    Explanation
    In Microsoft Excel 2003, the option "Insert/ Chart" allows users to create a chart for the selected range of values. This option provides a variety of chart types, including bar charts and column charts, to visualize and analyze data effectively.

    Rate this question:

  • 27. 

    Trong Microsoft Excel, bieu do loai nao thich hop cho viec hien thi gia tri dudi dang % (percentage)?

    • Pie

    • Column

    • Line

    Correct Answer
    A. Pie
    Explanation
    A pie chart is the most suitable type of chart for displaying values in percentage format. In a pie chart, the whole circle represents 100% and each slice represents a proportionate percentage of the whole. This makes it easy to visualize the distribution of percentages and compare different categories.

    Rate this question:

  • 28. 

    Trong Microsoft Excel, ham nao de tim gia tri trung binh cua cac gia tri duoc chon?

    • EVERAGE

    • AVERAGE

    • ERVERAGE

    Correct Answer
    A. AVERAGE
    Explanation
    The correct answer is "AVERAGE". In Microsoft Excel, the AVERAGE function is used to calculate the average value of a selected range of cells. It adds up all the values in the range and then divides the sum by the number of cells with numeric values. This function is commonly used in data analysis to find the average of a set of numbers.

    Rate this question:

  • 29. 

    Trong Microsoft Excel, cach nao de thoat khoi chuang trinh?

    • Shift+F4

    • Alt+F4

    • Ctrl+F4

    Correct Answer
    A. Alt+F4
    Explanation
    Alt+F4 is the correct answer because it is a keyboard shortcut commonly used to close a program or window in Microsoft Windows. In Microsoft Excel, pressing Alt+F4 will close the Excel program, allowing the user to exit the application.

    Rate this question:

  • 30. 

    Trong Microsoft Excel 2003, cach nao de chen mot cot truoc cot hien hanh?

    • Insert/ Columns

    • Insert/ Column left

    • Insert/mow Columns

    Correct Answer
    A. Insert/ Columns
    Explanation
    To insert a column before the current column in Microsoft Excel 2003, the correct option is "Insert/Columns". This option allows the user to add a new column to the left of the selected column, shifting the existing columns to the right. This is a useful feature when rearranging data or adding new information in a worksheet.

    Rate this question:

  • 31. 

    Trong Microsoft Excel 2003，thao tac nao de xoa mot hang trong bang tinh?

    • Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row

    • Chon o tai hang can xoa/ Kich phai chuot/ Delete/ Row above

    • Chon o tai hang can xoa/ Kich phai chuQt/ Delete/ Row

    Correct Answer
    A. Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row
    Explanation
    In Microsoft Excel 2003, to delete a row in a spreadsheet, you need to first select the cell in the row you want to delete. Then, right-click on the selected cell and choose the "Delete" option from the menu that appears. Finally, select the "Entire Row" option to delete the entire row.

    Rate this question:

  • 32. 

    Trong Microsoft Excel 2003，thao tac nao de xoa mot cot trong bang tinh?

    • Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column right

    • Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column

    • Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column

    Correct Answer
    A. Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column
    Explanation
    To delete a column in Microsoft Excel 2003, you need to select the cell in the column you want to delete, right-click on it, choose "Delete," and then select "Entire Column." This will delete the entire column from the worksheet.

    Rate this question:

  • 33. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro sang trai cua o

    • Ctrl + Tab

    • Alt + Tab

    • Shift + Tab

    Correct Answer
    A. Shift + Tab
    Explanation
    The correct answer is Shift + Tab. In Microsoft Excel, pressing Shift + Tab allows you to move the cursor to the left of a cell. This keyboard shortcut is useful for navigating between cells in a spreadsheet and can help improve efficiency when working with large amounts of data.

    Rate this question:

  • 34. 

    Trong Microsoft Excel, cach nao de dat con tro vao trong mot o da chon?

    • F5

    • F3

    • F2

    Correct Answer
    A. F2
    Explanation
    In Microsoft Excel, pressing the F2 key allows the user to move the cursor inside a selected cell. This is useful when editing the contents of a cell or making changes to the formula within the cell.

    Rate this question:

  • 35. 

    Trong Microsoft Excel 2003，thao tac nao cho phep thay doi lai kieu bieu do?

    • Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK

    • Kich chuot phai vao duong vien cua bieu do/ Chart Window/ chon lai kieu/OK

    • Kicli chuot phai vao duang vien cua bieu do/ Chart Options/ Chon lai kieu/ OK

    Correct Answer
    A. Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK
    Explanation
    In Microsoft Excel 2003, to change the chart type, you need to right-click on the border of the chart, select "Chart Type," choose the desired type, and click "OK." This action allows you to modify the chart type and customize it according to your needs.

    Rate this question:

  • 36. 

    Trong Microsoft Excel 2003，cong cu nao cho phep thay doi mau sac cho vung duoc chon?

    • Cong cu Fill Color tren thanh dinh dang

    • Cong cu Line Color tren thanh dinh dang

    • Cong cu Font Color tren thanh dinh dang

    Correct Answer
    A. Cong cu Fill Color tren thanh dinh dang
    Explanation
    The correct answer is "Cong cu Fill Color tren thanh dinh dang" (The Fill Color tool in the Formatting toolbar). This tool allows users to change the color of the selected range in Microsoft Excel 2003. It is used to fill cells, shapes, or objects with a specific color.

    Rate this question:

  • 37. 

    Trong Microsoft Excel,o A2 co du* lieu "Tin hoc van phong" ; tai o B2 nhap cong thuc =UPPER(A2) thi nhan duoc ket qua nao?

    • TIN HOC VAN PHONG

    • Tin Hoc Van Phong

    • TINHOCVANPHONG

    Correct Answer
    A. TIN HOC VAN PHONG
    Explanation
    The correct answer is "TIN HOC VAN PHONG". The formula =UPPER(A2) in cell B2 converts the text in cell A2 to uppercase letters. Therefore, the text "Tin hoc van phong" is converted to "TIN HOC VAN PHONG".

    Rate this question:

  • 38. 

    So hang va so cot trong Excel 2007 gap bao nhieu lan so voi Excel 2003?

    • So hang gap 10 lan va so cot gap 60 lan

    • So hang gap 6 lan va so cot gap 4 lan

    • So hang gap 16 lan va so cot gap 64 lan

    Correct Answer
    A. So hang gap 16 lan va so cot gap 64 lan
    Explanation
    The correct answer is that the number of rows in Excel 2007 is 16 times greater than in Excel 2003, and the number of columns is 64 times greater. This means that Excel 2007 can handle much larger datasets compared to Excel 2003, allowing for more extensive data analysis and manipulation.

    Rate this question:

  • 39. 

    Trong Microsoft Excel, cach nao cho phep di chuyen con tro den vi tri man hinh khuat phai

    • Shift+ Page Down

    • Ctrl + Page Down

    • Alt + Page Down

    Correct Answer
    A. Alt + Page Down
    Explanation
    The correct answer is Alt + Page Down. This keyboard shortcut allows the user to move the cursor to the rightmost visible position on the screen in Microsoft Excel. Using this shortcut is helpful when working with large spreadsheets that require horizontal scrolling.

    Rate this question:

  • 40. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro den vi tri man hinh khuat trai?

    • Ctrl + Page Up

    • Shift + Page Up

    • Alt 十 Page Up

    Correct Answer
    A. Alt 十 Page Up
    Explanation
    The correct answer is "Alt 十 Page Up". This key combination allows the cursor to move to the leftmost hidden position on the screen.

    Rate this question:

  • 41. 

    Trong Microsoft Excel, phim nao cho phep di chuyen con tro den cot dau tien cua dong hien tai?

    • Home

    • Page Down

    • Page Up

    Correct Answer
    A. Home
    Explanation
    The Home key in Microsoft Excel allows the cursor to move to the first column of the current row.

    Rate this question:

  • 42. 

    Trong Microsoft Excel 2003, cach nao de sap xep du: lieu theo thur ty giam dan?

    • Data/ Sort/ Descending

    • Data/ Sort/ Ascending

    • Data/ Sort by/ Descending

    Correct Answer
    A. Data/ Sort/ Descending
    Explanation
    In Microsoft Excel 2003, to sort data in descending order, you can go to the "Data" tab and select "Sort". From there, choose the "Descending" option. This will arrange the data in reverse order, from highest to lowest.

    Rate this question:

  • 43. 

    Trong Microsoft Excel, cong thirc =COUNT(19,l 1,4) se tra ve ket qua la bao nhieu?

    • 34

    • 3

    • 19

    Correct Answer
    A. 3
    Explanation
    The correct answer is 3 because the COUNT function in Microsoft Excel is used to count the number of cells in a range that contains numbers. In this case, the range specified is (19, l 1, 4), which means there are three numbers in the range. Therefore, the COUNT function will return the value 3.

    Rate this question:

  • 44. 

    Trong Microsoft Excel, cong thuc nao cho phep xep thu tu vung gia tri so A2:A10 theo chieu tang dan?

    • =rank(A2,$A$2:$A$10,0)

    • =rank(A2,$A$2:$A$10)

    • =rank(A2,$A$2:$A$10,1)

    Correct Answer
    A. =rank(A2,$A$2:$A$10,1)
    Explanation
    The correct answer is "=rank(A2,$A$2:$A$10,1)". This formula uses the RANK function in Excel to rank the value in cell A2 against the range of values in cells A2 to A10. The "1" as the third argument in the formula indicates that the ranking should be in ascending order, so the values in the range A2:A10 will be sorted in increasing order.

    Rate this question:

  • 45. 

    Trong Microsoft Excel,o A2 co du lieu ”TINHOC"; Tai o B2 nhap cong thuc =VALUE(A2) thi nhan duoc ket qua nao?

    • 6

    • #VALUE!

    • TINHOC

    Correct Answer
    A. #VALUE!
    Explanation
    The formula =VALUE(A2) in Microsoft Excel attempts to convert the value in cell A2 into a numeric value. However, since the value in A2 is "TINHOC" which is a text value, it cannot be converted into a numeric value. Therefore, the result of the formula is #VALUE!, indicating that the conversion was not possible.

    Rate this question:

  • 46. 

    Trong Microsoft Excel, cong thuc = AVERAGE(4,5,MIN(8,6,7)) cho ket qua nao?

    • 4

    • 5

    • 8

    Correct Answer
    A. 5
    Explanation
    The AVERAGE function in Microsoft Excel calculates the average of a set of numbers. In this case, the formula = AVERAGE(4,5,MIN(8,6,7)) is used. The MIN function is used to find the minimum value among the numbers 8, 6, and 7, which is 6. Therefore, the AVERAGE function will calculate the average of 4, 5, and 6, which is 5. Hence, the correct answer is 5.

    Rate this question:

  • 47. 

    Trong Microsoft Excel, cach nao de mo hop thoai thiet lap cac thong so in bang tinh?

    • Ctrl + P

    • Ctrl + Print Screen

    • Atl + P

    Correct Answer
    A. Ctrl + P
    Explanation
    To open the print settings dialog box in Microsoft Excel, you can use the keyboard shortcut Ctrl + P. This shortcut allows you to quickly access the print options and configure the settings for printing the spreadsheet. By pressing Ctrl + P, you can specify the printer, choose the number of copies, select the desired page range, adjust the print orientation, and make other necessary adjustments before printing the worksheet.

    Rate this question:

  • 48. 

    Trong M icrosoft Excel 2003，cach nao de chen mot hang phia tren hang hien hanh?

    • Insert/ New Rows

    • Insert/ Rows

    • Insert/ Row above

    Correct Answer
    A. Insert/ Rows
    Explanation
    To insert a row above the current row in Microsoft Excel 2003, you need to go to the "Insert" tab and select "Rows" from the drop-down menu. This will add a new row above the current row, shifting the existing rows down.

    Rate this question:

  • 49. 

    Trong Microsoft Excel 2003, thao tac nao sau day cho phep co dinh cot A va hang 1 trong khi cuon cac hang hoac cac cot khac?

    • Chon o B2/ Window/ Freeze Panes

    • Chon o B1/ Window/ Freeze Panes

    • Chon o A1/ Window/ Freeze Panes

    Correct Answer
    A. Chon o B2/ Window/ Freeze Panes
    Explanation
    In Microsoft Excel 2003, selecting cell B2 and then going to the Window menu and choosing Freeze Panes allows you to freeze column A and row 1 while scrolling through other columns or rows.

    Rate this question:

Quiz Review Timeline (Updated): Jun 25, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 25, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 05, 2014
    Quiz Created by
    Minhpd.87

Recent Quizzes

BASIC 6 COMPUTING QUIZ BASIC 6 COMPUTING QUIZ
Data Analyst Excel Test Data Analyst Excel Test
9th Grade Excel Test 9th Grade Excel Test
Keystone Bank Pre-Training Assessment Keystone Bank Pre-Training Assessment
Microsoft Excel Proficiency Trivia questions Microsoft Excel Proficiency Trivia questions
Test How Much Do You Know About Excel Sheets! Trivia Test How Much Do You Know About Excel Sheets! Trivia
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.