Exam Job Expert

MS EXCEL

1 / 20

To add two cells (Al and A(2) together you use the following formula ?

2 / 20

Using the F11 shortcut key to create a chart on chart sheet creates ?

3 / 20

Which of the following displays the contents of the active cell ?

4 / 20

Which button do you click to add up a series of numbers ?

5 / 20

What function displays row data in a column or column data in a row ?

6 / 20

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the ?

7 / 20

Hyperlinks can be ?

8 / 20

Using the AutoSum button will replace in the selected cell ...... ?

9 / 20

The multiplication arithmetic operator is represented by which of the following symbols ?

10 / 20

All formula in Excel start with ?

11 / 20

The intersection of a row and column is called ?

12 / 20

To create a formula in Excel, you can use ?

13 / 20

When you link data maintained in an excel workbook to a word document ?

14 / 20

Two common wildcard characters that Excel recognizes are ?

 

15 / 20

You can create hyperlinks from the Excel workbook to ?

16 / 20

An excel workbook is a collection of ?

17 / 20

When you insert an Excel file into a Word document, the data are ?

18 / 20

Excel files have a default extension of ?

19 / 20

Which area in an excel window allows entering values and formulas ?

20 / 20

Each cell in a Microsoft Office Excel document is referred to by its cell address, which is the ____________ ?

Your score is

The average score is 0%

0%

MS WORD

1 / 20

If you type a word that is not in Word's dictionary, a wavy _________ underline appears below the word. ?

2 / 20

Editing a document consists of reading through the document you've created, then ?

3 / 20

The ___________ button on the Quick Access Tollbar allows you to cancel your recent commands or actions ?

4 / 20

In order to save an existing document with a different name you need to ?

5 / 20

Which of the following shortcut key is used to check spelling ?

6 / 20

The word processing task associated with changing the appearance of documents is ?

7 / 20

What is the default file extension for all Word documents ?

8 / 20

Word processing, spreadsheet, and photo-editing are examples of _______. ?

9 / 20

Why are headers and footers used in document ?

10 / 20

Which of the following displays the buttons for changing text style, alignment and size ?

11 / 20

What menu is selected to print ?

12 / 20

The quickest and easiest way in Word, to locate a particular word or phrase in a document is to use the _________ command ?

13 / 20

What type of software is used for creating letters papers and other documents ?

14 / 20

Changing an existing document is called ________ the document ?

15 / 20

To print a document, press __________ then press ENTER ?

16 / 20

What does Ctrl + B shortcut accomplish in Ms-Word ?

17 / 20

Graphics for word processor ?

18 / 20

In order to save a Word document as a web page you need to ?

19 / 20

A saved document is referred to as a __________ ?

20 / 20

A word processor would most likely be used to do which of the following ?

Your score is

The average score is 0%

0%

COMPUTER FUNDAMENTAL MISCELLANEOUS

1 / 20

Who has created LISP, the Programming Language for Artificial Intelligence ?

2 / 20

In the field of computing, what does VRML stand for ?

3 / 20

In a computer, which unit is responsible for processing data and is also called the electronic brain of the computer ?

4 / 20

Which of the following symbols must be used before a formula in a Microsoft Excel sheet ?

5 / 20

Which of the following pairs is NOT matched correctly ?

6 / 20

Who has developed the Automatically Programmable Tool (APT) ?

7 / 20

What is the full form of BASIC in context of the BASIC computer language ?

8 / 20

Which of the following consists of an electronic writing area and a special ‘pen’ that works with it ?

9 / 20

In which year did the JavaScript Programming language come into existence ?

10 / 20

The F7 key is commonly used in Microsoft programs such as Microsoft Word, Outlook, etc. for: ?

11 / 20

Which of the following options correctly defines a firewall (in the context of computing) ?

12 / 20

In the world of Computers, what is ‘Ubuntu’ ?

13 / 20

In which of the following countries was the first Electronic Numerical Integrator and Computer, the first programmable general purpose electronic digital computer, developed ?

14 / 20

1 Petabyte (PB) = 1024 ______ ?

15 / 20

In the context of computers, WORM is an acronym of: ?

16 / 20

Which of the following converts analogue information into digital form ?

17 / 20

Which function key displays the Print Preview window in Microsoft Office ?

18 / 20

In the field of computing, what does VGA stand for ?

19 / 20

A hard disk is an example of which type of data storage device ?

20 / 20

A region of computer memory where frequently accessed data can be stored for rapid access is called: ?

Your score is

The average score is 0%

0%

COMPUTER FUNDAMENTAL MISCELLANEOUS

1 / 20

Who among the following invented the Computer language, COBOL ?

2 / 20

The first barcode system was developed by: ?

3 / 20

Which of the following is used to receive and send computer files over telephone lines ?

4 / 20

_____ was a web browser developed by the National Centre for Supercomputing Application (NCSA) ?

5 / 20

In Microsoft Office 2016, which shortcut key is used to open the Design tab ?

6 / 20

What does HLL stand for in computing ?

7 / 20

Which of the following is not a softcopy devices ?

8 / 20

Which of the following is a very high-speed semiconductor memory which can speed up the CPU ?

9 / 20

Which of the following is a type of memory and is similar to RAM? It is used by computers to move data between the RAM and the CPU ?

10 / 20

Which of the following is a lever that can be moved in several directions to control the movement of an image on a computer monitor or similar display screen ?

11 / 20

Which function key is used for opening help ?

12 / 20

Which technology do third generation computers use ?

13 / 20

In the context of memory size in computer data storage, one gigabyte is equal to how many megabytes ?

14 / 20

Linux is _____ ?

15 / 20

Python is a ______ ?

16 / 20

Which of the following is NOT an e-commerce website ?

17 / 20

Which shortcut key is used for previewing the page before printing?

18 / 20

Which of the following is NOT one of the tools of Robotics Process ?

19 / 20

In which year was Google incorporated as a private company ?

20 / 20

‘Pivot Table’ is a feature of which of the following softwares ?

Your score is

The average score is 73%

0%

COMPUTER FUNDAMENTAL MISCELLANEOUS

1 / 20

Which of the following is NOT a portable device ?

2 / 20

___ is the central server in computer network which lets the concerned user utilise the storage capacity of the server ?

3 / 20

What is the shortcut key for the central alignment of a line or text in MS Office software ?

4 / 20

Third generation computers used: ?

5 / 20

A computer on the Internet that uses HTTP protocol is known as: ?

6 / 20

How many function keys are present on a standard PC keyboard ?

7 / 20

Which type of computers is used to control air traffic and radar of national defence ?

8 / 20

Trackball is which of the following devices ?

9 / 20

Transistors belong to which of the following generation of the computers ?

10 / 20

Which of the following is an input device of a computer ?

11 / 20

Which of the following devices is NOT used to enter data into a computer ?

12 / 20

_____ is a small, portable flash memory card that plugs into a computer’s USB port and functions as a portable hard drive ?

13 / 20

In the context of computing, a byte is equal to _____ bits ?

14 / 20

Which of the following is an input device used to enter motion data in computers or other electronic devices ?

15 / 20

In the context of computing, what is the full form of URL ?

16 / 20

What is the full form of PROM ?

17 / 20

Which unit of the computer is considered as the brain of the computer ?

18 / 20

In the context of digital computer, which of the following pairs of digits is referred to as binary code ?

19 / 20

Which of the following is NOT an anti-virus software ?

20 / 20

_______ is the smallest unit of data in a computer ?

Your score is

The average score is 88%

0%

COMPUTER FUNDAMENTAL MISCELLANEOUS

1 / 21

In the context of digital computer, which of the following pairs of digits is referred to as binary code ?

2 / 21

Who among the following invented the World Wide Web (www) in 1989 ?

3 / 21

A database used by Microsoft Windows for storing configuration information is known as: ?

4 / 21

Which of the following is a supercomputer developed by India ?

5 / 21

In computing, _______ is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules. ?

6 / 21

In computer terminology, what is the full form of RAM ?

7 / 21

AIX is the operating system of which company ?

8 / 21

Second Generation computers can be characterized largely by their use of : ?

9 / 21

Who among the following pioneered Binary Logic and Arithmetic in Computers Programming ?

10 / 21

Desktop Computers, Laptop Computers, tablets and smartphones are different types of _______ ?

11 / 21

Who designed the first analog computer in India ?

12 / 21

What is ' Roadeo' ?

13 / 21

In the field of information and communication technology, what is the full form of FDD ?

14 / 21

Which company manufactured the first microprocessor 4004 ?

15 / 21

'Nibble' in computer terminology is also called ________ ?

16 / 21

Which of the following is an input device that utilises a light-sensitive detector to select objects on a display screen ?

17 / 21

Which of the following is an input device that utilises a light-sensitive detector to select objects on a display screen ?

18 / 21

The speed of the Central Processing Unit (CPU) is measured in_________, which represents a CPU cycle ?

19 / 21

In the field of computing, what does ENIAC stand for ?

20 / 21

_____ is a diagrammatic representation of a program logic. ?

21 / 21

_____ is the fastest to read from and write to than the other kinds of storage in a computer. ?

Your score is

The average score is 76%

0%

Declarations and Initializations

1 / 20

1 :typedef long a;
extern int a c;
2 :typedef long a;
extern a int c;
3 :typedef long a;
extern a c;

2 / 20

Which of the following correctly represents a long double constant?

3 / 20

Which of the following operations are INCORRECT?

4 / 20

Which of the declaration is correct?

5 / 20

What is the output of the program

#include<stdio.h>int main(){    struct emp    {        char name[20];        int age;        float sal;    };    struct emp e = {"Tiger"};    printf("%d, %f\n", e.age, e.sal);    return 0;}

6 / 20

What is the output of the program in Turbo C (in DOS 16-bit OS)?

#include<stdio.h>int main(){    char *s1;    char far *s2;    char huge *s3;    printf("%d, %d, %d\n", sizeof(s1), sizeof(s2), sizeof(s3));    return 0;}

7 / 20

What is the output of the program?

#include<stdio.h>int main(){    extern int a;    printf("%d\n", a);    return 0;}int a=20;

8 / 20

What will be the output of the program in 16 bit platform (Turbo C under DOS)?

#include<stdio.h>int main(){    extern int i;    i = 20;    printf("%d\n", sizeof(i));    return 0;}

9 / 20

What is the output of the program given below ?

#include<stdio.h>int main(){    enum status { pass, fail, atkt};    enum status stud1, stud2, stud3;    stud1 = pass;    stud2 = atkt;    stud3 = fail;    printf("%d, %d, %d\n", stud1, stud2, stud3);    return 0;}

10 / 20

When we mention the prototype of a function?

11 / 20

In the following program where is the variable a getting defined and where it is getting declared?

#include<stdio.h>int main(){    extern int a;    printf("%d\n", a);    return 0;}int a=20;

12 / 20

Identify which of the following are declarations

1 :extern int x;
2 :float square ( float x ) { ... }
3 :double pow(double, double);

13 / 20

Is the following statement a declaration or definition?
extern int i;

14 / 20

Which of the following is not user defined data type?

1 :
struct book{    char name[10];    float price;    int pages;};
2 :
long int l = 2.35;
3 :
enum day {Sun, Mon, Tue, Wed};

15 / 20

By default a real number is treated as a

16 / 20

How would you round off a value from 1.66 to 2.0?

17 / 20

Is there any difference between following declarations?

1 :extern int fun();
2 :int fun();

18 / 20

Which of the following special symbol allowed in a variable name?

19 / 20

What are the types of linkages?

20 / 20

Which of the following statements should be used to obtain a remainder after dividing 3.14 by 2.1 ?

Your score is

The average score is 0%

0%

Pointers

1 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    void *vp;    char ch=74, *cp="JACK";    int j=65;    vp=&ch;    printf("%c", *(char*)vp);    vp=&j;    printf("%c", *(int*)vp);    vp=cp;    printf("%s", (char*)vp+2);    return 0;}

2 / 20

What will be the output of the program if the size of pointer is 4-bytes?

#include<stdio.h>int main(){    printf("%d, %d\n", sizeof(NULL), sizeof(""));    return 0;}

3 / 20

What will be the output of the program ?

#include<stdio.h>int *check(static int, static int);int main(){    int *c;    c = check(10, 20);    printf("%d\n", c);    return 0;}int *check(static int i, static int j){    int *p, *q;    p = &i;    q = &j;    if(i >= 45)        return (p);    else        return (q);}

4 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    char *str;    str = "%s";    printf(str, "K\n");    return 0;}

5 / 20

What will be the output of the program ?

#include<stdio.h>void fun(void *p);int i;int main(){    void *vptr;    vptr = &i;    fun(vptr);    return 0;}void fun(void *p){    int **q;    q = (int**)&p;    printf("%d\n", **q);}

6 / 20

Which of the following statements correct about k used in the below statement?
char ****k;

7 / 20

Which of the following statements correctly declare a function that receives a pointer to pointer to a pointer to a float and returns a pointer to a pointer to a pointer to a pointer to a float?

8 / 20

What will be the output of the program If the integer is 4bytes long?

#include<stdio.h>int main(){    int ***r, **q, *p, i=8;    p = &i;    q = &p;    r = &q;    printf("%d, %d, %d\n", *p, **q, ***r);    return 0;}

9 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    char str[20] = "Hello";    char *const p=str;    *p='M';    printf("%s\n", str);    return 0;}

10 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    int x=30, *y, *z;    y=&x; /* Assume address of x is 500 and integer is 4 byte size */    z=y;    *y++=*z++;    x++;    printf("x=%d, y=%d, z=%d\n", x, y, z);    return 0;}

11 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    int i=3, *j, k;    j = &i;    printf("%d\n", i**j*i+*j);    return 0;}

12 / 20

What will be the output of the program ?

#include<stdio.h>int main(){    static char *s[] = {"black", "white", "pink", "violet"};    char **ptr[] = {s+3, s+2, s+1, s}, ***p;    p = ptr;    ++p;    printf("%s", **p+1);    return 0;}

13 / 20

The operator used to get value at address stored in a pointer variable is

14 / 20

A pointer is

15 / 20

What would be the equivalent pointer expression for referring the array element a[i][j][k][l]

16 / 20

If a variable is a pointer to a structure, then which of the following operator is used to access data members of the structure through the pointer variable?

17 / 20

How many bytes are occupied by near, far and huge pointers (DOS)?